<?php
class xl_search{
    function read_products($id){
        global $dbh;
        $sql='SELECT * FROM product WHERE alias LIKE :id';
        $sth=$dbh->prepare($sql);
        $sth->execute(array(':id'=>"%$id%"));
        return $sth->fetchAll(); 
    }
}